CREATE TABLE "USER_" (

"USER_USER_FIRSTNAME" VARCHAR(255) DEFAULT NULL,
"USER_USER_LASTNAME" VARCHAR(255) DEFAULT NULL,
"USER_USER_COUNTRY" VARCHAR(255) DEFAULT NULL,
"USER_USER_LEVEL" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("USER_USER_LEVEL") REFERENCES "USER_USER_LEVEL" ("ID") ON DELETE CASCADE,
"USER_USERNAME" VARCHAR(255) NOT NULL, PRIMARY KEY ("USER_USERNAME"));
CREATE TABLE "A_NEWENTRY_" (

"A_NEWENTRY_NEWENTRY_SOURCETYPE" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("A_NEWENTRY_NEWENTRY_SOURCETYPE") REFERENCES "A_NEWENTRY_NEWENTRY_SOURCETYPE" ("ID") ON DELETE CASCADE,
"A_NEWENTRY_NEWENTRY_LEVEL" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("A_NEWENTRY_NEWENTRY_LEVEL") REFERENCES "A_NEWENTRY_NEWENTRY_LEVEL" ("ID") ON DELETE CASCADE,
"A_NEWENTRY_NEWENTRY_REGION" VARCHAR(255) DEFAULT NULL,
"A_NEWENTRY_NEWENTRY_REPORTINGDATE" DATETIME DEFAULT NULL,
"A_NEWENTRY_NEWENTRY_YEAROFREFERENCE" INT DEFAULT NULL,
"A_NEWENTRY_NEWENTRY_POLICE_CUSTOMSFILEIDENTIF" VARCHAR(255) DEFAULT NULL,
"A_NEWENTRY_NEWENTRY_PUBLICPROSECUTORSFILEIDEN" VARCHAR(255) DEFAULT NULL,
"A_NEWENTRY_NEWENTRY_COURTSFILEIDENTIFICATIONN" VARCHAR(255) DEFAULT NULL,
"A_NEWENTRY_USER_USERNAME" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("A_NEWENTRY_USER_USERNAME") REFERENCES "USER_" ("USER_USERNAME") ON DELETE CASCADE,
"B_1_EVENTS_DIGEST" VARCHAR(255) DEFAULT NULL,

"B_1_EVENTS_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"B_1_EVENTS_ACTIVITIES_RECRUITMENT" BIT DEFAULT NULL,
"B_1_EVENTS_ACTIVITIES_TRANSPORTATION" BIT DEFAULT NULL,
"B_1_EVENTS_ACTIVITIES_TRANSFER" BIT DEFAULT NULL,
"B_1_EVENTS_ACTIVITIES_HARBOURING" BIT DEFAULT NULL,
"B_1_EVENTS_ACTIVITIES_RECEIPTOFPERSONS" BIT DEFAULT NULL,
"B_1_EVENTS_RECRUITMENT_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_PERSONALCONTACT" BIT DEFAULT NULL,
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_NEWSPAPERADVERTISEMENT" BIT DEFAULT NULL,
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_RADIOADVERTISEMENT" BIT DEFAULT NULL,
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_INTERNETADVERTISEMENT" BIT DEFAULT NULL,
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_TELEVISIONADVERTISEMENT" BIT DEFAULT NULL,
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_SOLDBYFAMILYMEMBER" BIT DEFAULT NULL,
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_KIDNAPPED" BIT DEFAULT NULL,
"B_1_EVENTS_MANNEROFINITIATIONOFCONTA_OTHERALLFIELDSBUTTHESEALR" BIT DEFAULT NULL,
"B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION") REFERENCES "B_1_EVENTS_DURATIONOFTRANSPORTATION_DURATIONOFTRANSPORTATION" ("ID") ON DELETE CASCADE,
"B_1_EVENTS_MEANSOFTRANSPORTUSED_CAR" BIT DEFAULT NULL,
"B_1_EVENTS_MEANSOFTRANSPORTUSED_BUS" BIT DEFAULT NULL,
"B_1_EVENTS_MEANSOFTRANSPORTUSED_TRAIN" BIT DEFAULT NULL,
"B_1_EVENTS_MEANSOFTRANSPORTUSED_BOAT" BIT DEFAULT NULL,
"B_1_EVENTS_MEANSOFTRANSPORTUSED_AIRPLANE" BIT DEFAULT NULL,
"B_1_EVENTS_MEANSOFTRANSPORTUSED_TRUCK_CONTAINER" BIT DEFAULT NULL,
"B_1_EVENTS_MEANSOFTRANSPORTUSED_BYFOOT" BIT DEFAULT NULL,
"B_1_EVENTS_NATIONSCROSSEDDURINGTHETR_COUNTRYOFORIGIN" VARCHAR(255) DEFAULT NULL,
"B_1_EVENTS_NATIONSCROSSEDDURINGTHETR_COUNTRYSTRANSITED" VARCHAR(255) DEFAULT NULL,
"B_1_EVENTS_NATIONSCROSSEDDURINGTHETR_COUNTRYOFDESTINATION" VARCHAR(255) DEFAULT NULL,
"B_1_EVENTS_BORDERSCROSSED_GREENBORDER" BIT DEFAULT NULL,
"B_1_EVENTS_BORDERSCROSSED_BLUEBORDER" BIT DEFAULT NULL,
"B_1_EVENTS_BORDERSCROSSED_UNKNOWN" BIT DEFAULT NULL,
"B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_EXPLOITATIONDURINGTRANSPO" BIT DEFAULT NULL,
"B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION") REFERENCES "B_1_EVENTS_EXPLOITATIONINTHETRANSPOR_TYPEOFEXPLOITATION" ("ID") ON DELETE CASCADE,
"B_1_EVENTS_PLACESOFHARBOURING_APARTMENT_PRIVATEDWELLING" BIT DEFAULT NULL,
"B_1_EVENTS_PLACESOFHARBOURING_HOTEL_MOTEL" BIT DEFAULT NULL,
"B_1_EVENTS_PLACESOFHARBOURING_CAMPINGAREA" BIT DEFAULT NULL,
"B_1_EVENTS_PLACESOFHARBOURING_PLACEOFEXPLOITATION" BIT DEFAULT NULL,
"B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION") REFERENCES "B_1_EVENTS_DURATIONOFEXPLOITATION_DURATIONOFEXPLOITATION" ("ID") ON DELETE CASCADE,
"B_1_EVENTS_SEXUALEXPLOITATION_SEXUALEXPLOITATION" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFSEXUALEXPLOITATION_PROSTITUTION" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFSEXUALEXPLOITATION_CHILDPROSTITUTION" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFSEXUALEXPLOITATION_PORNOGRAPHY" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFSEXUALEXPLOITATION_CHILDPORNOGRAPHY" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFSEXUALEXPLOITATION_SEXTOURISM" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFSEXUALEXPLOITATION_OTHER" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_OUTDOOR" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_INDOOR_APARTMENT" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_INDOOR_BROTHEL" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_INDOOR_SAUNA" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_INDOOR_CLUB" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_INDOOR_HOTEL_MOTEL" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_INDOOR_PUB_BAR" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_CALLGIRLS_ESCORTSERVICE" BIT DEFAULT NULL,
"B_1_EVENTS_PLACEOFSEXUALEXPLOITATION_OTHER" BIT DEFAULT NULL,
"B_1_EVENTS_LABOUREXPLOITATION_LABOUREXPLOITATION" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFLABOUREXPLOITATION_SLAVERY" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFLABOUREXPLOITATION_COMPULSORYWORK" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFLABOUREXPLOITATION_BONDEDLABOUR" BIT DEFAULT NULL,
"B_1_EVENTS_SECTOROFLABOUREXPLOITATIO_AGRICULTURE" BIT DEFAULT NULL,
"B_1_EVENTS_SECTOROFLABOUREXPLOITATIO_INDUSTRY" BIT DEFAULT NULL,
"B_1_EVENTS_SECTOROFLABOUREXPLOITATIO_COMMERCE" BIT DEFAULT NULL,
"B_1_EVENTS_SECTOROFLABOUREXPLOITATIO_SERVICES" BIT DEFAULT NULL,
"B_1_EVENTS_SECTOROFLABOUREXPLOITATIO_PRIVATE" BIT DEFAULT NULL,
"B_1_EVENTS_SECTOROFLABOUREXPLOITATIO_LEISURE" BIT DEFAULT NULL,
"B_1_EVENTS_OTHERFORMSOFEXPLOITATION_OTHERFORMSOFEXPLOITATION" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFOTHEREXPLOITATION_BEGGING" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFOTHEREXPLOITATION_LOW_LEVELCRIMINALITY" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFOTHEREXPLOITATION_STREET_SELLING" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFOTHEREXPLOITATION_REMOVALOFORGANS" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFOTHEREXPLOITATION_MILITARYSERVICE" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFOTHEREXPLOITATION_ILLEGALADOPTION" BIT DEFAULT NULL,
"B_1_EVENTS_TYPEOFOTHEREXPLOITATION_OTHERALLFIELDSBUTTHESEALR" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_RAPE" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_FORGERY" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_FRAUD" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_COUNTERFEITING" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_UNDECLAREDLABOUR" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_KEEPINGABROTHEL" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_BRIBERYOFPUBLICOFFICIALS" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_ILLEGALIMMIGRATION" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_CHILDPORNOGRAPHY" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_SEXUALASSAULT" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_SEXTOURISM" BIT DEFAULT NULL,
"B_1_EVENTS_ACTCTXTRAFFICKING_OTHER" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_MISUSEOFPOSITIONOROFAPOSI" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_ADMINISTRATIONOFDRUG_MEDI" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_ABDUCTION" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_RESTRICTIONSONFREEDOMOFMO" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_TAKESDOCUMENTSAWAYFROMVIC" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_BYMEANSOFDECEPTION" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_PROMISEOFMARRIAGE_ENGAGEM" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_BYMEANSOFFORCE_THREATOROT" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_THROUGHDEBTBONDAGE" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_GIVINGORRECEIVINGPAYMENTS" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_CONTINUOUSCONTROLOVERTHEV" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_AGREEMENTWITHTHEAUTHOR" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_SALEOFPERSONINTOOWNERSHIP" BIT DEFAULT NULL,
"B_1_EVENTS_MODUSOPERANDI_OTHERALLFIELDSBUTTHESEALR" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_COLLABORATIONOFMORETHANTW" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_EACHWITHOWNAPPOINTEDTASKS" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_FORAPROLONGEDORINDEFINITE" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_USINGSOMEFORMOFDISCIPLINE" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_SUSPECTEDOFTHECOMMISSIONO" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_OPERATINGONANINTERNATIONA" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_USINGVIOLENCEOROTHERMEANS" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_USINGCOMMERCIALORBUSINESS" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_ENGAGEDINMONEYLAUNDERING" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_EXERTINGINFLUENCEONPOLITI" BIT DEFAULT NULL,
"B_1_EVENTS_INDICATORSOFORGANISEDCRIM_DETERMINEDBYTHEPURSUITOFP" BIT DEFAULT NULL,
"B_2_Victim_DIGEST" VARCHAR(255) DEFAULT NULL,

"B_2_Victim_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"B_2_VICTIM_PERSONALDATA_IDENTITY_NAME" VARCHAR(255) DEFAULT NULL,
"B_2_VICTIM_PERSONALDATA_ALIAS" VARCHAR(255) DEFAULT NULL,
"B_2_VICTIM_PERSONALDATA_NICKNAME" VARCHAR(255) DEFAULT NULL,
"B_2_VICTIM_PERSONALDATA_SEXOFTHEVICTIM" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_PERSONALDATA_SEXOFTHEVICTIM") REFERENCES "B_2_VICTIM_PERSONALDATA_SEXOFTHEVICTIM" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_PERSONALDATA_DATEOFBIRTH" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_2_VICTIM_PERSONALDATA_COUNTRYOFBIRTH" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_2_VICTIM_PERSONALDATA_PLACEOFBIRTH" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_2_VICTIM_PERSONALDATA_NATIONALITY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_2_VICTIM_PERSONALDATA_FINGERPRINTS" BIT DEFAULT NULL,
"B_2_VICTIM_PERSONALDATA_CRIMINALRECORD" BIT DEFAULT NULL,
"B_2_VICTIM_PERSONALDATA_MARITALSTATUS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_PERSONALDATA_MARITALSTATUS") REFERENCES "B_2_VICTIM_PERSONALDATA_MARITALSTATUS" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI") REFERENCES "B_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_PERSONALDATA_NO_OFCHILDRENOFTHEVICTIM" INT DEFAULT NULL,
"B_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS") REFERENCES "B_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI") REFERENCES "B_2_VICTIM_PERSONALDATA_STATUSOFTHEVICTIMTOWARDSI" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW") REFERENCES "B_2_VICTIM_LIVINGSITUATIONBEFOREDEPA_PERSONTHEVICTIMWASLIVINGW" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_COUNTRYORRESIDENCEBEFORED_COUNTRYOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_2_VICTIM_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT") REFERENCES "B_2_VICTIM_PLACEOFRESIDENCEBEFOREDEP_PLACEOFRESIDENCEOFTHEVICT" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_INCOME_OCCUPATIONOFTHEVICTIMBEFO" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_INCOME_OCCUPATIONOFTHEVICTIMBEFO") REFERENCES "B_2_VICTIM_INCOME_OCCUPATIONOFTHEVICTIMBEFO" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI") REFERENCES "B_2_VICTIM_ECONOMICSTATUSBEFOREDEPAR_PERCEPTIONOFTHEVICTIMOFHI" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_MOTIVESOFTHEVICTIMTOMIGRA_IMPROVINGECONOMICALSTATUS" BIT DEFAULT NULL,
"B_2_VICTIM_MOTIVESOFTHEVICTIMTOMIGRA_SEARCHINGABETTERFUTURE" BIT DEFAULT NULL,
"B_2_VICTIM_MOTIVESOFTHEVICTIMTOMIGRA_POLITICALINSTABILITYINTHE" BIT DEFAULT NULL,
"B_2_VICTIM_MOTIVESOFTHEVICTIMTOMIGRA_PERSONALRELATIONSHIPWITHT" BIT DEFAULT NULL,
"B_2_VICTIM_MOTIVESOFTHEVICTIMTOMIGRA_OTHER" BIT DEFAULT NULL,
"B_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON") REFERENCES "B_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION") REFERENCES "B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_SEXUALEXPLOITATION" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION") REFERENCES "B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_LABOUREXPLOITATION" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION") REFERENCES "B_2_VICTIM_ROLEORPROFESSIONOFTHEVICT_OTHERFORMSOFEXPLOITATION" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_MONEYREQUESTED_PAID_VICTIMIS_SOLD_FROMONEGROU" BIT DEFAULT NULL,
"B_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM") REFERENCES "B_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS") REFERENCES "B_2_VICTIM_MONEYREQUESTED_PAID_VICTIMSDEBTTOWARDSAUTHORS" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_PERSDOCSEIZURE_SEIZUREOFVICTIMSDOCUMENTS" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_WORKPERMIT" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_ASYLUMREQUEST" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_IDENTITYCARD" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_PASSPORT" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_DRIVINGLICENSE" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_VISA" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_BIRTHCERTIFICATE" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_MARRIAGECERTIFICATE" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_ORDERTOLEAVETHECOUNTRY" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_RESIDENCEPERMIT" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_OTHER" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCSEIZURE_NODOCUMENTSUSED" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_USEOFFORGEDDOCUMENTS" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_WORKPERMIT" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_ASYLUMREQUEST" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_IDENTITYCARD" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_PASSPORT" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_DRIVINGLICENSE" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_VISA" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_BIRTHCERTIFICATE" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_MARRIAGECERTIFICATE" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_ORDERTOLEAVETHECOUNTRY" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_RESIDENCEPERMIT" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_OTHER" BIT DEFAULT NULL,
"B_2_VICTIM_PERSDOCFORGED_NODOCUMENTSUSED" BIT DEFAULT NULL,
"B_2_VICTIM_RE_VICTIMISATION_RE_VICTIMISATION" BIT DEFAULT NULL,
"B_2_VICTIM_RE_VICTIMISATION_OFTHESAMECRIME" BIT DEFAULT NULL,
"B_2_VICTIM_RE_VICTIMISATION_SAMEAREAOFEXPLOITATION" BIT DEFAULT NULL,
"B_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION") REFERENCES "B_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX") REFERENCES "B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEDAILYINCOMEFROMSEX" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR") REFERENCES "B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEINCOMEFROMOTHERFOR" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML") REFERENCES "B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_AVERAGEMONTHLYINCOMEFROML" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_AVERAGEINCOMEFROMEXPLOITA_INCOMERECEIVEDFORREMOVALO" BIT DEFAULT NULL,
"B_2_VICTIM_BACKGROUNDOFVICTIMSCLIENT_LOCALS" BIT DEFAULT NULL,
"B_2_VICTIM_BACKGROUNDOFVICTIMSCLIENT_INTERNATIONALS" BIT DEFAULT NULL,
"B_2_VICTIM_BACKGROUNDOFVICTIMSCLIENT_MILITARY" BIT DEFAULT NULL,
"B_2_VICTIM_BACKGROUNDOFVICTIMSCLIENT_POLICE" BIT DEFAULT NULL,
"B_2_VICTIM_BACKGROUNDOFVICTIMSCLIENT_CIVILIANS" BIT DEFAULT NULL,
"B_2_VICTIM_BACKGROUNDOFVICTIMSCLIENT_OTHER" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_POLICE" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_JUDICIALAUTHORITY" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_NGO" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_GO" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_HOSPITALORMEDICALFACILITI" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_INDIVIDUAL" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_HOTLINE" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_OUTREACHSERVICES" BIT DEFAULT NULL,
"B_2_VICTIM_FIRSTASSISTANCEREFERRAL_OTHERAPPLICABLEWHENNOOTHE" BIT DEFAULT NULL,
"B_2_VICTIM_INSTITUTIONPROVIDINGASSIS_INSTITUTION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_INSTITUTIONPROVIDINGASSIS_INSTITUTION") REFERENCES "B_2_VICTIM_INSTITUTIONPROVIDINGASSIS_INSTITUTION" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_SELFEMPLOYMENT" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_VOCATIONALTRAINING" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_GRANT_SCHEME" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_MICRO_CREDIT" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_JOBREFERRALSUBSIDISEDEMPL" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_EDUCATION" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_LEGALCOUNSELLING" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_MEDICALREFERRALORASSISTAN" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_TEMPORARYRESIDENCEPERMIT" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_COVERINGDOCUMENTS" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_FAMILYSUPPORT" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_HOUSING" BIT DEFAULT NULL,
"B_2_VICTIM_KINDOFASSISTANCEPROVIDED_SHELTER" BIT DEFAULT NULL,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_TEMPORARYSAFEACCOMMODATIO" BIT DEFAULT NULL,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_FACILITATIONOFVISA_TRAVEL" BIT DEFAULT NULL,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_TRAVELARRANGEMENTS" BIT DEFAULT NULL,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_DISBURSEMENTOFATRAVEL_RE_" BIT DEFAULT NULL,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_RISKASSESSMENTONORIGINCOU" BIT DEFAULT NULL,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_SECURINGOFTEMPORARYDOCUME" BIT DEFAULT NULL,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO") REFERENCES "B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_PLACETHEVICTIMCANGOTO" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING") REFERENCES "B_2_VICTIM_ASSISTANCEPROVIDEDFORRETU_MEANSOFSUPPORTING" ("ID") ON DELETE CASCADE,
"B_2_VICTIM_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_2_VICTIM_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH") REFERENCES "B_2_VICTIM_INTENTIONSOFTHEVICTIMUPON_INTENTIONOFTHEVICTIMUPONH" ("ID") ON DELETE CASCADE,
"B_3_Author_DIGEST" VARCHAR(255) DEFAULT NULL,

"B_3_Author_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"B_3_AUTHOR_PERSONALDATA_IDENTITY_NAMEALTERNATIVEL" VARCHAR(255) DEFAULT NULL,
"B_3_AUTHOR_PERSONALDATA_ALIAS" VARCHAR(255) DEFAULT NULL,
"B_3_AUTHOR_PERSONALDATA_NICKNAME" VARCHAR(255) DEFAULT NULL,
"B_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR") REFERENCES "B_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR") REFERENCES "B_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_PERSONALDATA_DATEOFBIRTHOFTHEAUTHOR_DA" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_3_AUTHOR_PERSONALDATA_COUNTRYOFBIRTH_ESTABLISHM" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_3_AUTHOR_PERSONALDATA_PLACEOFBIRTH_ESTABLISHMEN" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_3_AUTHOR_PERSONALDATA_NATIONALITY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_3_AUTHOR_PERSONALDATA_COUNTRYOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"B_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE") REFERENCES "B_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_PERSONALDATA_FINGERPRINTS" BIT DEFAULT NULL,
"B_3_AUTHOR_PERSONALDATA_CRIMINALRECORD" BIT DEFAULT NULL,
"B_3_AUTHOR_PERSONALDATA_RECORDFORTRAFFICKING" BIT DEFAULT NULL,
"B_3_AUTHOR_PERSONALDATA_MARITALSTATUS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_PERSONALDATA_MARITALSTATUS") REFERENCES "B_3_AUTHOR_PERSONALDATA_MARITALSTATUS" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS") REFERENCES "B_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR") REFERENCES "B_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_INCOME_STATUSOFTHEAUTHORTOWARDSI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_INCOME_STATUSOFTHEAUTHORTOWARDSI") REFERENCES "B_3_AUTHOR_INCOME_STATUSOFTHEAUTHORTOWARDSI" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_ORGANISEDCRIMINALGROUP_THEAUTHORISPARTOFANORGANI" BIT DEFAULT NULL,
"B_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE") REFERENCES "B_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("B_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN") REFERENCES "B_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN" ("ID") ON DELETE CASCADE,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_RECRUITER" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_PASSEUR" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_DRIVER" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_PREMISESOWNERTHETERMPREMI" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_PHOTOGRAPHER" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_IMPRESARIO" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_PIMP" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_DOORWAITER" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_MOVIEDIRECTOR" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_ENTREPRENEUR" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_CONTRACTOR" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_MIDDLEMAN" BIT DEFAULT NULL,
"B_3_AUTHOR_ROLEOFTHEAUTHORINTHECOMMI_OTHER" BIT DEFAULT NULL,
"B_3_AUTHOR_RELATIONSHIPAUTHOR_VICTIM_THEAUTHOROFTRANSPORTATION" BIT DEFAULT NULL,
"B_3_AUTHOR_RELATIONSHIPAUTHOR_VICTIM_NO_OFVICTIMSWITHWHOMTHEAU" BIT DEFAULT NULL,
"B_3_AUTHOR_RELATIONSHIPAUTHOR_VICTIM_THEAUTHORISFELLOWCITIZENW" BIT DEFAULT NULL,
"C_1_Event_DIGEST" VARCHAR(255) DEFAULT NULL,

"C_1_Event_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"C_1_EVENT_EVENTOFCHILDPORNOGRAPHY_EVENTOFCHILDPORNOGRAPHY" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTIVITIES_PRODUCTIONOFCHILDPORNOGRA" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTIVITIES_DISTRIBUTION_DISSEMINATIO" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTIVITIES_VIATHEINTERNET_DISTRIBUTI" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTIVITIES_SUPPLYINGORMAKINGAVAILABL" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTIVITIES_VIATHEINTERNET_SUPPLYINGO" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTIVITIES_ACQUISITIONOFCHILDPORNOGR" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTIVITIES_POSSESSIONOFCHILDPORNOGRA" BIT DEFAULT NULL,
"C_1_EVENT_ECPDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ECPDURATIONOFTHEEVENT_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_1_EVENT_ECPDURATIONOFTHEEVENT_DURATION") REFERENCES "C_1_EVENT_ECPDURATIONOFTHEEVENT_DURATION" ("ID") ON DELETE CASCADE,
"C_1_EVENT_ECPCOUNTRYOFTHEEVENT_COUNTRY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ECPMEANSUSEDTOMAKECHILDPO_THEINTERNET" BIT DEFAULT NULL,
"C_1_EVENT_ECPMEANSUSEDTOMAKECHILDPO_MAIL_EXPRESSCOURIER" BIT DEFAULT NULL,
"C_1_EVENT_ECPMEANSUSEDTOMAKECHILDPO_PERSONALCONTACT" BIT DEFAULT NULL,
"C_1_EVENT_ECPSEIZUREOFCHILDPORNOGRA_SEIZUREOFPORNOGRAPHICMEDI" BIT DEFAULT NULL,
"C_1_EVENT_ECPSEIZUREOFCHILDPORNOGRA_IDENTIFIEDVICTIMS" BIT DEFAULT NULL,
"C_1_EVENT_ECPSEIZUREOFCHILDPORNOGRA_NOTAREALCHILD" BIT DEFAULT NULL,
"C_1_EVENT_ECPSEIZUREOFCHILDPORNOGRA_IDENTIFIEDAUTHORWHOISSEXU" BIT DEFAULT NULL,
"C_1_EVENT_ECPSEIZUREOFCHILDPORNOGRA_CONVICTEDAUTHOR" BIT DEFAULT NULL,
"C_1_EVENT_ECPSEIZUREOFCHILDPORNOGRA_SUSPECTAUTHOR" BIT DEFAULT NULL,
"C_1_EVENT_ECPNUMBEROFPICTURESSEIZED_NUMBEROFPICTURESSEIZED" INT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_HACKINGCOMPUTERPROTECTION" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_SEXUALASSAULT" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_RAPE" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_CHILDPROSTITUTION" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_UNDECLAREDEMPLOYMENT" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_COUNTERFEITING" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_ABDUCTION" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_KEEPINGABROTHEL" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_TRAFFICKINGINHUMANBEINGS" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_ABUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_ADMINISTRATIONOFDRUGS_MED" BIT DEFAULT NULL,
"C_1_EVENT_ECPACTCTXCHILDPRONOGRAPHY_DECEPTIONOFTHEVICTIMINORD" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_VIATHEINTERNET" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_SEXUALINTERCOURSE" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_SEXUALAGGRESSION" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_THROUGHEROTIC_PORNOGRAPHI" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_MISUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_ADMINISTRATIONOFDRUGS" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_ADMINISTRATIONOFMEDICINES" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_TAKESVICTIMAWAY" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_LOCKSVICTIMAWAY_TIESHIM_H" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_BYMEANSOFDECEPTION" BIT DEFAULT NULL,
"C_1_EVENT_ECPMODUSOPERANDI_BYMEANSOFFORCE_THREAT" BIT DEFAULT NULL,
"C_1_EVENT_EVENTOFSEXUALASSAULT_EVENTOFSEXUALASSAULT" BIT DEFAULT NULL,
"C_1_EVENT_ESASEXUALASSAULTDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ESADURATIONOFTHEEVENT_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_1_EVENT_ESADURATIONOFTHEEVENT_DURATION") REFERENCES "C_1_EVENT_ESADURATIONOFTHEEVENT_DURATION" ("ID") ON DELETE CASCADE,
"C_1_EVENT_ESACOUNTRYOFTHEEVENT_COUNTRYOFTHEEVENT" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_RAPE" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_CHILDPROSTITUTION" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_UNDECLAREDEMPLOYMENT" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_COUNTERFEITING" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_KEEPINGABROTHEL" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_TRAFFICKINGINHUMANBEINGS" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_ABUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_ADMINISTRATIONOFDRUGS_MED" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_ABDUCTION" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_DECEPTIONOFTHEVICTIMINORD" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_CHILDPORNOGRAPHY" BIT DEFAULT NULL,
"C_1_EVENT_ESAACTCTXSEXUALASSAULT_BRIBERY" BIT DEFAULT NULL,
"C_1_EVENT_ESAMODUSOPERANDI_SEXUALINTERCOURSE" BIT DEFAULT NULL,
"C_1_EVENT_ESAMODUSOPERANDI_SEXUALAGGRESSION" BIT DEFAULT NULL,
"C_1_EVENT_ESAMODUSOPERANDI_MISUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ESAMODUSOPERANDI_ADMINISTRATIONOFDRUGS_MED" BIT DEFAULT NULL,
"C_1_EVENT_ESAMODUSOPERANDI_ABDUCTION" BIT DEFAULT NULL,
"C_1_EVENT_ESAMODUSOPERANDI_BYMEANSOFDECEPTION" BIT DEFAULT NULL,
"C_1_EVENT_ESAMODUSOPERANDI_BYMEANSOFFORCE_THREAT" BIT DEFAULT NULL,
"C_1_EVENT_EVENTOFSEXTOURISM_EVENTOFSEXTOURISM" BIT DEFAULT NULL,
"C_1_EVENT_ESTSEXTOURINSMDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ESTDURATIONOFTHEEVENT_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_1_EVENT_ESTDURATIONOFTHEEVENT_DURATION") REFERENCES "C_1_EVENT_ESTDURATIONOFTHEEVENT_DURATION" ("ID") ON DELETE CASCADE,
"C_1_EVENT_ESTCOUNTRYOFTHEEVENT_COUNTRYOFTHEEVENT" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_RAPE" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_CHILDPROSTITUTION" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_UNDECLAREDEMPLOYMENT" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_COUNTERFEITING" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_LOCKINGUPVICTIM" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_KEEPINGABROTHEL" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_TRAFFICKINGINHUMANBEINGS" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_ABUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_ADMINISTRATIONOFDRUGS_MED" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_ABDUCTION" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_CHILDPORNOGRAPHY" BIT DEFAULT NULL,
"C_1_EVENT_ESTOFFENCESCOMMITTEDINTHE_BRIBERY" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_VIATHEINTERNET" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_SEXUALINTERCOURSE" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_SEXUALAGGRESSION" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_PAYMENTFOREACHSERVICE" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_MISUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_ADMINISTRATIONOFDRUGS_MED" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_ABDUCTION" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_BYMEANSOFDECEPTION" BIT DEFAULT NULL,
"C_1_EVENT_ESTMODUSOPERANDI_BYMEANSOFFORCE_THREAT" BIT DEFAULT NULL,
"C_1_EVENT_EVENTOFCHILDPROSTITUTION_EVENTOFCHILDPROSTITUTION" BIT DEFAULT NULL,
"C_1_EVENT_ECPRODATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ECPRODATEOFDURATION_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_1_EVENT_ECPRODATEOFDURATION_DURATION") REFERENCES "C_1_EVENT_ECPRODATEOFDURATION_DURATION" ("ID") ON DELETE CASCADE,
"C_1_EVENT_ECPROCOUNTRYOFTHEEVENT_COUNTRYOFTHEEVENT" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_RAPE" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_UNDECLAREDEMPLOYMENT" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_COUNTERFEITING" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_LOCKINGUPVICTIM" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_KEEPINGABROTHEL" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_TRAFFICKINGINHUMANBEINGS" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_ABUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_ADMINISTRATIONOFDRUGS_MED" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_ABDUCTION" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_CHILDPORNOGRAPHY" BIT DEFAULT NULL,
"C_1_EVENT_ECPROOFFENCESCOMMITTEDINT_BRIBERY" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_VIATHEINTERNET" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_SEXUALINTERCOURSE" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_SEXUALAGGRESSION" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_MISUSEOFPOSITION" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_ADMINISTRATIONOFDRUGS" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_ADMINISTRATIONOFMEDICINES" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_TAKESVICTIMAWAY" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_LOCKSVICTIMAWAY_TIESHIM_H" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_BYMEANSOFDECEPTION" BIT DEFAULT NULL,
"C_1_EVENT_ECPROMODUSOPERANDI_BYMEANSOFFORCE_THREAT" BIT DEFAULT NULL,
"C_2_Victim_DIGEST" VARCHAR(255) DEFAULT NULL,

"C_2_Victim_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"C_2_VICTIM_PERSONALDATA_IDENTITY_NAME" VARCHAR(255) DEFAULT NULL,
"C_2_VICTIM_PERSONALDATA_ALIAS" VARCHAR(255) DEFAULT NULL,
"C_2_VICTIM_PERSONALDATA_NICKNAME" VARCHAR(255) DEFAULT NULL,
"C_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM") REFERENCES "C_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_PERSONALDATA_DATEOFBIRTHOFTHEVICTIM" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_2_VICTIM_PERSONALDATA_AGEOFSEXUALCONSENTINYOURC" INT DEFAULT NULL,
"C_2_VICTIM_PERSONALDATA_VICTIMISUNDERTHEAGEOFCONS" BIT DEFAULT NULL,
"C_2_VICTIM_PERSONALDATA_COUNTRYOFBIRTH" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_2_VICTIM_PERSONALDATA_PLACEOFBIRTH" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_2_VICTIM_PERSONALDATA_NATIONALITY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_2_VICTIM_PERSONALDATA_FINGERPRINTS" BIT DEFAULT NULL,
"C_2_VICTIM_PERSONALDATA_CRIMINALRECORD" BIT DEFAULT NULL,
"C_2_VICTIM_PERSONALDATA_MARITALSTATUS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_PERSONALDATA_MARITALSTATUS") REFERENCES "C_2_VICTIM_PERSONALDATA_MARITALSTATUS" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI") REFERENCES "C_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS") REFERENCES "C_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI") REFERENCES "C_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_PERSONALDATA_COUNTRYOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCE") REFERENCES "C_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCE" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM") REFERENCES "C_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON") REFERENCES "C_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_MONEYREQUESTED_PAID_VICTIMIS_SOLD_FROMONEGROU" BIT DEFAULT NULL,
"C_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM") REFERENCES "C_2_VICTIM_MONEYREQUESTED_PAID_PRICEPAIDFORTHEVICTIM" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_RE_VICTIMISATION_RE_VICTIMISATION" BIT DEFAULT NULL,
"C_2_VICTIM_RE_VICTIMISATION_OFTHESAMECRIME" BIT DEFAULT NULL,
"C_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION") REFERENCES "C_2_VICTIM_RE_VICTIMISATION_AREAOFEXPLOITATION" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_POLICE" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_JUDICIALAUTHORITY" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_NGO" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_GO" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_HOSPITALORMEDICALFACILITI" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_INDIVIDUAL" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_HOTLINE" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_OUTREACHSERVICES" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_OTHER" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION") REFERENCES "C_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION" ("ID") ON DELETE CASCADE,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_GRANT_SCHEME" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_EDUCATION" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_LEGALCOUNSELLING" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_MEDICALREFERRALORASSISTAN" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_FAMILYSUPPORT" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_PSYCHOLOGICALASSISTANCE" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_HOUSING" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_SHELTER" BIT DEFAULT NULL,
"C_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_OTHER" BIT DEFAULT NULL,
"C_3_Author_DIGEST" VARCHAR(255) DEFAULT NULL,

"C_3_Author_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"C_3_AUTHOR_PERSONALDATA_IDENTITY_NAME" VARCHAR(255) DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_ALIAS" VARCHAR(255) DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_NICKNAME" VARCHAR(255) DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR") REFERENCES "C_3_AUTHOR_PERSONALDATA_PERSONALITYOFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR") REFERENCES "C_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_PERSONALDATA_DATEOFBIRTHOFTHEAUTHOR" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_3_AUTHOR_PERSONALDATA_COUNTRYOFBIRTH_ESTABLISHM" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_3_AUTHOR_PERSONALDATA_PLACEOFBIRTH_ESTABLISHMEN" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_3_AUTHOR_PERSONALDATA_NATIONALITY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_3_AUTHOR_PERSONALDATA_COUNTRYOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"C_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE") REFERENCES "C_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_PERSONALDATA_FINGERPRINTS" BIT DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_CRIMINALRECORD" BIT DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_RECORDFORCHILDPORNOGRAPHY" BIT DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_RECORDFORSEXUALASSAULT" BIT DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_RECORDFORCHILDPROSTITUTIO" BIT DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_RECORDFORSEXTOURISM" BIT DEFAULT NULL,
"C_3_AUTHOR_PERSONALDATA_MARITALSTATUS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_PERSONALDATA_MARITALSTATUS") REFERENCES "C_3_AUTHOR_PERSONALDATA_MARITALSTATUS" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS") REFERENCES "C_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR") REFERENCES "C_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_ORGANISEDCRIMINALGROUP_THEAUTHORISPARTOFANORGANI" BIT DEFAULT NULL,
"C_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE") REFERENCES "C_3_AUTHOR_ORGANISEDCRIMINALGROUP_NO_OFMEMBERSOFTHEORGANISE" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("C_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN") REFERENCES "C_3_AUTHOR_ORGANISEDCRIMINALGROUP_ROLEOFTHEAUTHORINTHEORGAN" ("ID") ON DELETE CASCADE,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_RECRUITER" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_PASSEUR" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_DRIVER" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_PREMISESOWNERTHETERMPREMI" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_PHOTOGRAPHER" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_IMPRESARIO" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_FACILITATOR" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_DOORWAITER" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_MOVIEDIRECTOR" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_DISTRIBUTOR_SELLEROFCHILD" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_RECEIVER_PURCHASEROFCHILD" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_MIDDLEMAN" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_CONTRACTOR" BIT DEFAULT NULL,
"C_3_AUTHOR_ROLEOFTHEAUTHORCOMMISSION_OTHER" BIT DEFAULT NULL,
"C_3_AUTHOR_RELATIONSHIPAUTHOR_VICTIM_NO_OFVICTIMSWITHWHOMTHEAU" INT DEFAULT NULL,
"C_3_AUTHOR_RELATIONSHIPAUTHOR_VICTIM_THEAUTHORISFELLOWCITIZENW" BIT DEFAULT NULL,
"D_1_Event_DIGEST" VARCHAR(255) DEFAULT NULL,

"D_1_Event_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"D_1_EVENT_RUNAWAYS_" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_RUNAWAYSDURATIONOFTHEEVEN_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_1_EVENT_RUNAWAYSDURATIONOFTHEEVEN_DURATION") REFERENCES "D_1_EVENT_RUNAWAYSDURATIONOFTHEEVEN_DURATION" ("ID") ON DELETE CASCADE,
"D_1_EVENT_RUNAWAYSCOUNTRYWHERETHEEV_COUNTRY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_RUNAWAYSCOUNTRIESOFACCOMM_COUNTRIES" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_RUNAWAYSPLACE_PERSONWHERE_PARENTS" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSPLACE_PERSONWHERE_MOTHER" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSPLACE_PERSONWHERE_FATHER" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSPLACE_PERSONWHERE_FAMILYMEMBER" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSPLACE_PERSONWHERE_FOSTERPARENTS" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSPLACE_PERSONWHERE_INSTITUTION" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_CAR" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_BUS" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_TRAIN" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_BOAT" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_AIRPLANE" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_TRUCK_CONTAINER" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_BYFOOT" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_BICYCLE" BIT DEFAULT NULL,
"D_1_EVENT_RUNAWAYSMEANSOFTRANSPORTU_MOTORBIKEORMOTORCYCLE" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTIONBYATHIRDPERSON_ABDUCTIONBYATHIRDPERSON" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_ABDUCTI3RDPERSONDURATIONO_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_1_EVENT_ABDUCTI3RDPERSONDURATIONO_DURATION") REFERENCES "D_1_EVENT_ABDUCTI3RDPERSONDURATIONO_DURATION" ("ID") ON DELETE CASCADE,
"D_1_EVENT_ABDUCTI3RDPERSONCOUNTRYWH_COUNTRY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_ABDUCTI3RDPERSONCOUNTRIES_COUNTRIES" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_ABDUCTI3RDPERSONACTIVITIE_SIMPLEABDUCTION" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONACTIVITIE_ABDUCTIONBYFORCE_THREATOF" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONACTIVITIE_PUTSTHEVICTIMINDANGEROFDE" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONACTIVITIE_THEACTCAUSESTHEDEATHOFTHE" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONACTIVITIE_THEAUTHORENRICHESHIMSELF" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_CAR" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_BUS" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_TRAIN" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_BOAT" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_AIRPLANE" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_TRUCK_CONTAINER" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_BYFOOT" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_BICYCLE" BIT DEFAULT NULL,
"D_1_EVENT_ABDUCTI3RDPERSONMEANSOFTR_MOTORBIKEORMOTORCYCLE" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTION_PARENTALABDUCTION" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_PARENTALABDUCTDURATIONOFT_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_1_EVENT_PARENTALABDUCTDURATIONOFT_DURATION") REFERENCES "D_1_EVENT_PARENTALABDUCTDURATIONOFT_DURATION" ("ID") ON DELETE CASCADE,
"D_1_EVENT_PARENTALABDUCTCOUNTRYWHER_COUNTRY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_PARENTALABDUCTCOUNTRIESOF_COUNTRIES" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_PARENTALABDUCTACTIVITIESC_SIMPLEABDUCTION" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTACTIVITIESC_ABDUCTIONBYFORCE_THREATOF" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTACTIVITIESC_PUTSTHEVICTIMINDANGEROFDE" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTACTIVITIESC_THEACTCAUSESTHEDEATHOFTHE" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTACTIVITIESC_THEAUTHORENRICHESHIMSELF" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_CAR" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_BUS" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_TRAIN" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_BOAT" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_AIRPLANE" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_TRUCK_CONTAINER" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_BYFOOT" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_BICYCLE" BIT DEFAULT NULL,
"D_1_EVENT_PARENTALABDUCTMEANSOFTRAN_MOTORBIKEORMOTORCYCLE" BIT DEFAULT NULL,
"D_1_EVENT_LOST_INJUREDOROTHERWISEMI_" BIT DEFAULT NULL,
"D_1_EVENT_LOSTINFUREDMISSDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_LOSTINFUREDMISSDURATIONOF_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_1_EVENT_LOSTINFUREDMISSDURATIONOF_DURATION") REFERENCES "D_1_EVENT_LOSTINFUREDMISSDURATIONOF_DURATION" ("ID") ON DELETE CASCADE,
"D_1_EVENT_LOSTINFUREDMISSCOUNTRYWHE_COUNTRY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_LOSTINFUREDMISSCOUNTRIESO_COUNTRIES" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_PLACEWHERETHECHILDGOTLOST_CITY" BIT DEFAULT NULL,
"D_1_EVENT_PLACEWHERETHECHILDGOTLOST_SCHOOL" BIT DEFAULT NULL,
"D_1_EVENT_PLACEWHERETHECHILDGOTLOST_VACATION" BIT DEFAULT NULL,
"D_1_EVENT_PLACEWHERETHECHILDGOTLOST_FOREIGNCOUNTRY" BIT DEFAULT NULL,
"D_1_EVENT_PLACEWHERETHECHILDGOTLOST_YOUTHCAMP" BIT DEFAULT NULL,
"D_1_EVENT_PLACEWHERETHECHILDGOTLOST_OTHERCROWDEDPLACES" BIT DEFAULT NULL,
"D_1_EVENT_MISSINGUNACCOMPANIEDMIGRA_MISSINGUNACCOMPANIEDMIGRA" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGDATE_PERIODOFTHEEVENT" DATETIME DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGDURATIONOFTHEE_DURATION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_1_EVENT_MISSUNACMIGDURATIONOFTHEE_DURATION") REFERENCES "D_1_EVENT_MISSUNACMIGDURATIONOFTHEE_DURATION" ("ID") ON DELETE CASCADE,
"D_1_EVENT_MISSUNACMIGCOUNTRYOFTHEEV_COUNTRY" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_MISSUNACMIGCOUNTRIESOFACC_COUNTRIES" VARCHAR(255) DEFAULT NULL,
-- UNKNOWN IS NOT USED IN THE PROJECT
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_SEIZUREOFVICTIMSDOCUMENTS" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_WORKPERMIT" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_ASYLUMREQUEST" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_IDENTITYCARD" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_PASSPORT" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_DRIVINGLICENSE" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_VISA" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_BIRTHCERTIFICATE" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_MARRIAGECERTIFICATE" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_ORDERTOLEAVETHECOUNTRY" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_RESIDENCEPERMIT" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_OTHER" BIT DEFAULT NULL,
"D_1_EVENT_MISSUNACMIGPERSONALDOCUME_NODOCUMENTSUSED" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_USEOFFORGEDDOCUMENTS" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_WORKPERMIT" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_ASYLUMREQUEST" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_IDENTITYCARD" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_PASSPORT" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_DRIVINGLICENSE" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_VISA" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_BIRTHCERTIFICATE" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_MARRIAGECERTIFICATE" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_ORDERTOLEAVETHECOUNTRY" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_RESIDENCEPERMIT" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_OTHER" BIT DEFAULT NULL,
"D_1_EVENT_PERSONALDOCUMENTSFORGED_NODOCUMENTSUSED" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_TRAFFICKINGINHUMANBEINGS" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_RAPE" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_FORGERY" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_BRIBERY" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_KIDNAPPING" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_LOCKINGUPOFPERSONS" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_SEXUALASSAULT" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_SEXTOURISM" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_PROSTITUTION" BIT DEFAULT NULL,
"D_1_EVENT_ACTSCOMMITINTHECTXOFMISSI_PORNOGRAPHY" BIT DEFAULT NULL,
"D_2_Victim_DIGEST" VARCHAR(255) DEFAULT NULL,

"D_2_Victim_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"D_2_VICTIM_PERSONALDATA_IDENTITY_NAME" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_ALIAS" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_NICKNAME" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM") REFERENCES "D_2_VICTIM_PERSONALDATA_GENDEROFTHEVICTIM" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_PERSONALDATA_DATEOFBIRTH" DATETIME DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_COUNTRYOFBIRTH" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_PLACEOFBIRTH" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_NATIONALITY" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_FINGERPRINTS" BIT DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_CRIMINALRECORD" BIT DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_MARITALSTATUS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_PERSONALDATA_MARITALSTATUS") REFERENCES "D_2_VICTIM_PERSONALDATA_MARITALSTATUS" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI") REFERENCES "D_2_VICTIM_PERSONALDATA_STRUCTUREOFTHEFAMILYOFORI" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS") REFERENCES "D_2_VICTIM_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI") REFERENCES "D_2_VICTIM_PERSONALDATA_LIVINGSITUATIONOFTHEVICTI" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_PERSONALDATA_COUNTRYOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT") REFERENCES "D_2_VICTIM_PERSONALDATA_PLACEOFRESIDENCEOFTHEVICT" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM") REFERENCES "D_2_VICTIM_PERSONALDATA_OCCUPATIONOFTHEVICTIM" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON") REFERENCES "D_2_VICTIM_LIAISONBETWEENTHEVICTIMSA_LIAISON" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_RE_VICTIMISATION_RE_VICTIMISATION" BIT DEFAULT NULL,
"D_2_VICTIM_RE_VICTIMISATION_OFTHESAMECRIME" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_POLICE" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_JUDICIALAUTHORITY" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_NGO" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_GO" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_INDIVIDUAL" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_HOTLINE" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_OUTREACHSERVICES" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_HOSPITALORMEDICALFACILITI" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_FIRSTASSISTANCEREFERR_OTHERAPPLICABLEWHENNOOTHE" VARCHAR(255) DEFAULT NULL,
"D_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION") REFERENCES "D_2_VICTIM_ATV_INSTITUTIONPROVIDINGA_INSTITUTION" ("ID") ON DELETE CASCADE,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_SELFEMPLOYMENT" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_GRANT_SCHEME" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_MICRO_CREDIT" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_JOBREFERRALSUBSIDISEDEMPL" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_EDUCATION" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_LEGALCOUNSELLING" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_MEDICALREFERRALORASSISTAN" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_FAMILYSUPPORT" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_PSYCHOLOGICALASSISTANCE" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_HOUSING" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_SHELTER" BIT DEFAULT NULL,
"D_2_VICTIM_ATV_KINDOFASSISTANCEPROVI_OTHER" VARCHAR(255) DEFAULT NULL,
"D_3_Author_DIGEST" VARCHAR(255) DEFAULT NULL,

"D_3_Author_DIGEST_NFP" VARCHAR(255) DEFAULT NULL,

"D_3_AUTHOR_PERSONALDATA_IDENTITY_NAME" VARCHAR(255) DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_ALIAS" VARCHAR(255) DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_NICKNAME" VARCHAR(255) DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR") REFERENCES "D_3_AUTHOR_PERSONALDATA_GENDEROFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"D_3_AUTHOR_PERSONALDATA_DATEOFBIRTH" DATETIME DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_COUNTRYOFBIRTH" VARCHAR(255) DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_PLACEOFBIRTH" VARCHAR(255) DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_NATIONALITY" VARCHAR(255) DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_COUNTRYOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE") REFERENCES "D_3_AUTHOR_PERSONALDATA_PLACEOFRESIDENCE" ("ID") ON DELETE CASCADE,
"D_3_AUTHOR_PERSONALDATA_FINGERPRINTS" BIT DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_CRIMINALRECORD" BIT DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_RECORDFORABDUCTION" BIT DEFAULT NULL,
"D_3_AUTHOR_PERSONALDATA_MARITALSTATUS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_3_AUTHOR_PERSONALDATA_MARITALSTATUS") REFERENCES "D_3_AUTHOR_PERSONALDATA_MARITALSTATUS" ("ID") ON DELETE CASCADE,
"D_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS") REFERENCES "D_3_AUTHOR_PERSONALDATA_EDUCATIONINCLUDESPRIMARYS" ("ID") ON DELETE CASCADE,
"D_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR" VARCHAR(255) DEFAULT NULL,
FOREIGN KEY ("D_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR") REFERENCES "D_3_AUTHOR_INCOME_OCCUPATIONOFTHEAUTHOR" ("ID") ON DELETE CASCADE,
"ID" BIGINT NOT NULL PRIMARY KEY IDENTITY(1, 1), "DIGEST" VARCHAR(255) DEFAULT NULL);
